pp108 : DBConnectionPool (Managed Components)

DBConnectionPool (Managed Components)

This managed component type represents a pool of database connections.

Settings

allowQueryLanguageFallBack

Setting Type

Hot

Type

String

Description

Switching query language from DBSQL to DBVIEW automatically.
This applicable in case of OLEDB + SQL server where DBSQL represents fast-forward cursor and DBVIEW represents static cursor. Fast-forward cursor improves performance, but not all kinds of queries(like multiple table join) will not work(specifically in SQL server). So this flag switches the language(mentioned in constructor tag) to DBVIEW in case DBSQL is not working, for first execution

auditInfo

Setting Type

Hot

Type

String

Description

XML structure containing audit info

connectionPoolRefreshInterval

Setting Type

Hot

Type

Integer

Description

Refresh Interval for connection Pool
This will denote the time interval in which idle connections in the connection pool are removed

conversionConfig

Setting Type

Hot

Type

String

Description

XML structure containing data conversion info

cursorCacheRefreshInterval

Setting Type

Hot

Type

Integer

Description

Refresh interval for the query cache

cursorCacheSize

Setting Type

Hot

Type

Integer

Description

Size of the cursor cache per connection.

datasource

Setting Type

Hot

Type

String

Description

XML structure containing datasource info

defaultCursorSize

Setting Type

Hot

Type

Integer

Description

Default size of Cursor.

maximumReadConnections

Setting Type

Hot

Type

Integer

Description

Number of maximum read connections

maximumWriteConnections

Setting Type

Hot

Type

Integer

Description

Number of maximum write connections.

minimumReadConnections

Setting Type

Hot

Type

Integer

Description

Number of miniuum write connections.

minimumWriteConnections

Setting Type

Hot

Type

Integer

Description

Number of minimum write connections.

multibyte

Setting Type

Hot

Type

Boolean

Description

Multibyte support

multithreaded

Setting Type

Hot

Type

Boolean

Description

Single or multithreaded provider support

optimiseQueryForCursor

Setting Type

Hot

Type

Boolean

Description

Optimise query for retrieving first set of records using cursor

precedence

Setting Type

Hot

Type

String enumeration, possible values: 'data' and 'null'

Description

Data or null precedence

queryCacheRefreshInterval

Setting Type

Hot

Type

Integer

Description

Refresh interval for the query cache

queryCacheSize

Setting Type

Hot

Type

Integer

Description

Size of the query cache per connection.

reconnectionAttempts

Setting Type

Hot

Type

Integer

Description

Number of attempts to reconnect to the database server.

reconnectionInterval

Setting Type

Hot

Type

Integer

Description

Interval between two attempts to reconnect to the database server.

requestThreshold

Setting Type

Hot

Type

Integer

Description

Threshold value for each request.

xmlEncoding

Setting Type

Hot

Type

Integer

Description

Support for xml special characters.

xsiNilForNullData

Setting Type

Hot

Type

Integer

Description

Setting xsi:nil for absence of data along with null=true

Counters

numOfCachedReadConnections

Counter type

Value counter

Value

The number of read connections in the cache

Hints

 

numOfCachedWriteConnections

Counter type

Value counter

Value

The number of write connections in the cache

Hints

 

numberOfCachedQueries

Counter type

Value counter

Value

Number of currently cached queries in all connections.

Hints

 

numberOfOpenCursors

Counter type

Value counter

Value

Number of currently open cursors in all connections.

Hints

 

readConnectionUsageDuration

Counter type

Event value counter

Value

Frequency and duration of usage of a read connection

Hints

 

readConnectionWait

Counter type

Event value counter

Event

A request needed to wait for a read connection because the pool was empty

Value

Frequency and duration of wait actions for a read connection

Hints

 

writeConnectionUsageDuration

Counter type

Event Value Counter

Event

A write connection is returned to the connection pool

Value

Frequency and duration of usage of a write connection

Hints

 

writeConnectionWait

Counter type

Event Value Counter

Event

A request needed to wait for a write connection because the pool was empty

Value

Frequency and duration of wait actions for a write connection

Hints

 

Alerts

databaseConnectionFailure

Severity Level

Error

Message

The database server is not available. The database server may not be functioning, or the network may be encountering server connectivity problems. Ensure that the database server is functioning, and the network is communicating properly with the server.

Description

This alert is issued when connection to database server is lost.

databaseConnectionEstablished

Severity Level

Info

Message

Connection to the database Server has been established

Description

This alert is issued when connection to database server is successful.

Problems

DBConnectionFailure

problemRaiseDescription

This alert is issued when connection to database server is lost.

problemClearDescription

This alert is issued when connection to database server is successful.

Sub-components

The DBConnectionPool type has no sub-components.